import plotly.offline as pyo
from plotly.graph_objs import *
import chart_studio.plotly as py
import pandas as pd
from pandas import DataFrame
pyo.offline.init_notebook_mode()
expenseData = pd.read_csv(r"../Data/NumberOfMPsExpenseClaims_2010-2015.csv")
expenseData.head(5)
| month | NumberOfClaims2010 | NumberOfClaims2011 | NumberOfClaims2012 | NumberOfClaims2013 | NumberOfClaims2014 | NumberOfClaims2015 | |
|---|---|---|---|---|---|---|---|
| 0 | 1 | 14982 | 16594 | 18280 | 18096 | 15864 | 2728.0 |
| 1 | 2 | 14168 | 16060 | 16632 | 15954 | 14272 | 0.0 |
| 2 | 3 | 18678 | 19507 | 20934 | 21204 | 16946 | 1.0 |
| 3 | 4 | 3 | 13056 | 15158 | 18070 | 16146 | 5708.0 |
| 4 | 5 | 6404 | 15454 | 17693 | 17586 | 15725 | 11556.0 |
traces = []
for i in range(2010, 2016):
traces.append({'type' : 'scatter',
'x' : expenseData['month'],
'y' : expenseData['NumberOfClaims' + str(i)],
'name' : i,
'mode' : 'lines'})
data = Data(traces)
layout = {'title' : 'Number of Expenses by Month for 2010-2015',
'xaxis' : {'title' : 'Month'},
'yaxis' : {'title' : 'Yaxis title1'}}
fig = Figure(data = data, layout = layout)
pyo.iplot(fig)
markerSymbols = ['circle','square','diamond','x','triangle-up','cross']
traces = []
for i, yr in enumerate(range(2010, 2016)):
traces.append({'type' : 'scatter',
'x' : expenseData['month'],
'y' : expenseData['NumberOfClaims' + str(yr)],
'marker' : {'symbol' : markerSymbols[i]},
'name' : yr,
'mode' : 'lines+markers'})
data = Data(traces)
fig = Figure(data=data, layout=layout)
pyo.iplot(fig)
markerSymbolsOpen = ['circle-open','square-open','diamond-open','x-open','triangle-up-open','cross-open']
traces = []
for i, yr in enumerate(range(2010, 2016)):
traces.append({'type' : 'scatter',
'x' : expenseData['month'],
'y' : expenseData['NumberOfClaims' + str(yr)],
'marker' : {'symbol' : markerSymbolsOpen[i]},
'name' : yr,
'mode' : 'lines+markers'})
data = Data(traces)
fig = Figure(data = data, layout = layout)
pyo.iplot(fig)
markerSymbolsDot = ['circle-dot','square-dot','diamond-dot','x-dot','triangle-up-dot','cross-dot']
traces = []
for i, yr in enumerate(range(2010, 2016)):
traces.append({'type' : 'scatter',
'x' : expenseData['month'],
'y' : expenseData['NumberOfClaims' + str(yr)],
'marker' : {'symbol' : markerSymbolsDot[i], 'size' : 10, 'line' : {'width' : 1}},
'name' : yr,
'mode' : 'markers'})
data = Data(traces)
fig = Figure(data=data, layout=layout)
pyo.iplot(fig)
markerSymbolsOpenDot = ['circle-open-dot','square-open-dot','diamond-open-dot','x-open-dot','triangle-up-open-dot','cross-open-dot']
traces = []
for i, yr in enumerate(range(2010, 2016)):
traces.append({'type' : 'scatter',
'x' : expenseData['month'],
'y' : expenseData['NumberOfClaims' + str(yr)],
'marker' : {'symbol' : markerSymbolsOpenDot[i], 'size' : 10, 'line' : {'width' : 1}},
'name' : yr,
'mode' : 'markers'})
data = Data(traces)
fig = Figure(data=data, layout=layout)
pyo.iplot(fig)
markerSymbolsNum = [1,101,201,301,25,0]
traces = []
for i, yr in enumerate(range(2010, 2016)):
traces.append({'type' : 'scatter',
'x' : expenseData['month'],
'y' : expenseData['NumberOfClaims' + str(yr)],
'marker' : {'symbol' : markerSymbolsNum[i], 'size' : 10, 'line' : {'width' : 1}},
'name' : yr,
'mode' : 'markers'})
data2 = Data(traces)
fig = Figure(data=data2, layout=layout)
pyo.iplot(fig)